import openpyxl


def readExcel(excel,sheets):
    # 创建表格对象
    wb = openpyxl.load_workbook(excel)

    # 获取工作簿对象
    sheet = wb[f'{sheets}']

    # 循环打印输除表头以外的数据  mr+1
    mr = sheet.max_row
    mc = sheet.max_column
    totil = []
    for i in range(2, mr + 1):
        li = []
        for c in range(1, mc + 1):
            # print(sheet.cell(i,c).value,end='\t')
            li.append(sheet.cell(i, c).value)
        totil.append(li)
    return totil

# print(readExcel('../09-11/银行卡数据.xlsx', 'Sheet1'))